﻿CREATE TABLE [dbo].[TempInventories]
(
	Id int IDENTITY(1,1) NOT NULL,
	Date Date NOT NULL,
	StoreCode varchar(100) NOT NULL,
	ArticleCode varchar(100) NOT NULL,
	CategoryCode varchar(50), 
	Description varchar(200) NULL,
	EAN varchar(50) NULL,
	UOM varchar(50) NULL,
	Brand varchar(255) NULL,
	Manufacturer varchar(255) NULL,
	Quantity money NULL,
	Cost money NULL,
	Retail money NULL,
	GP money NULL,
	StoreId smallint NULL,
	ArticleId int NULL,
	CategoryId smallint NULL
)
